成绩<60 不及格成绩60—70 及格成绩71—89 中等成绩90—100 优秀否则 差 Excel单元格中输入: =IF(B3<60,"不及格",IF(B3<=70,"及格",IF(B3<=89,"中等",IF(B3<=100,"优秀","差"))))